2017-07-28 - 50314 - Spec - Components ATP report #MMPPSupport
SPECIFICATIONS
50314-Spec-Components ATP Report.
Purpose
Components ATP report.
Admin Info
| Purpose |
Components ATP Report |
| Requested By |
Babu Vanamali |
| Spec Created By |
Adithya |
| Spec Created Date |
07/28/2017 |
| Spec QA by |
Adithya |
| Objects |
ZMM_COMPONENTS_ATP |
| Document Status |
Complete |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
|
| 2 |
Documentation |
08 |
| 3 |
Development/ Config |
24 |
| 4 |
Unit test in DEV |
24 |
| 5 |
Unit test in QUA |
|
| 6 |
Other activity |
|
| TOTAL |
50 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]Documents
[Attach any document(s) received for the requirement(s)]Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
Add descriptions to MIDs and Sold to party Give Sales Order Creation date range Create Transaction- ZMM_COMPONENTS_ATP |
Babu Vanamali |
08/23/2017 |
|
| 2 |
Add Requested delivery date for ATP as input |
Babu Vanamali |
09/12/2017 |
|
| 3 |
Add Sales Order Quantities |
Babu Vanamali |
09/15/2017 |
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]Create a new report to populate components ATP information along with sales orders data to help make correct decision during hot market. This is a real time data report, business users will run this report as and when they need.
In Scope:
[List the activities to be included in scope]Out of Scope:
[Out of scope activities]Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Initially it was decided to go with creation of an info set but it did not work as per the requirement.
Create a report where as the program shall consider all the Open sales orders, then list the BOM components and do ATP check for those components and display the same in the report.
Inputs for the program are:
1. Materials - When Materials are given as input, program shall make the list of open sales orders and contracts for that materials and display the components of that material with ATP (Simulate and show /AFS/ATPS) and other fields of the report.
2. MRP Controllers: When MRP Controllers are given as input materials for those MRP Controllers are considered and those program shall make the list of open sales and contracts orders for those materials
display the components of that material with ATP (Simulate and show /AFS/ATPS) and other fields of the report.
3. There is another input "Sales Order Created date from" which shall bring the sales orders which are created after the date mentioned in the input.
By default the input date takes the date less than 180 days form the date executed.
Any of the Input is mandatory: MRP Controller or the Material.
On 08/23/2017
Add FG Material Description, Components Material Description, Sold to party description
Give date range for input sales order in the initial screen.
Create transaction for the program "ZMM_COMPONENTS_ATP"
On 09/05/2017 Identified below bugs while testing in QAS:
1. ATP Quantity showing for the Raw Material.
2. Wrong BOM Components Explosion for ROAL Materials (Materials explosion from Super BOM)
3. Raw Material Unrestricted stock shown up as Blank (since those are non batch materials sotck is considered from MARD table)
On 09/12/2017
Add Requested Delivery date for ATP as input as shown in the below screen, so that the atp quantity will be simulated and BOM explosion would be taken place on that date.
On 09/15/2017
Add sales order quantity next to unrestricted quantity in the report.
Test Plan
[List test scenarios/cases to be executed here]
| Test ID |
Test Scenario |
Expected Results |
| ATP01 |
Execute the report creating Sales Order for Materials having MRP Controllers 002, 104, 201, 301, 302 & 303 |
The Components of the Materials used in the sales order shall be displayed with the other fields in the report. |
| ATP02 |
Create a Sales Order for the Materials having no BOM |
The Materials with the sales order shall not be shown up in the report. |
| ATP03 |
Validate the date, Consider a old Open sales Order which is created before the given input date |
The Materials with the sales order shall not be shown up in the report. |
| ATP04 |
Execute the program with the Materials as inputs |
The Sales order which are open shall be displayed with the Materials and the components with ATP data |
[Provide complete technical details for configuration or programming here]
Created a program "ZMM_COMPONENTS_ATP" which shall give all the details as per the requirement.
Issues
[List Issues / Bugs identified in configuration or development]
2017-08-21 - 50314 - Rel Notes - Components ATP Report
2017-09-11 - 50314 - Rel Notes - Components ATP Report
2017-09-18 - 50314 - Rel Notes - ATP Components Report